October 15, 2018
| BeerName | Beer_ID | ABV | IBU | Style | Ounces | BreweryName | Brewery_ID | City | State |
|---|---|---|---|---|---|---|---|---|---|
| Get Together | 2692 | 0.045 | 50 | American IPA | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Maggie's Leap | 2691 | 0.049 | 26 | Milk / Sweet Stout | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Wall's End | 2690 | 0.048 | 19 | English Brown Ale | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Pumpion | 2689 | 0.060 | 38 | Pumpkin Ale | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Stronghold | 2688 | 0.060 | 25 | American Porter | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Parapet ESB | 2687 | 0.056 | 47 | Extra Special / Strong Bitter (ESB) | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
Caption: Here is a quick glance at the head of our merged dataset. You can see we created easy to read captions and merged the two raw datasets with our renames field "Brewery_ID".
| BeerName | Beer_ID | ABV | IBU | Style | Ounces | BreweryName | Brewery_ID | City | State | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2405 | Pilsner Ukiah | 98 | 0.055 | NA | German Pilsener | 12 | Ukiah Brewing Company | 556 | Ukiah | CA |
| 2406 | Heinnieweisse Weissebier | 52 | 0.049 | NA | Hefeweizen | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2407 | Snapperhead IPA | 51 | 0.068 | NA | American IPA | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2408 | Moo Thunder Stout | 50 | 0.049 | NA | Milk / Sweet Stout | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2409 | Porkslap Pale Ale | 49 | 0.043 | NA | American Pale Ale (APA) | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2410 | Urban Wilderness Pale Ale | 30 | 0.049 | NA | English Pale Ale | 12 | Sleeping Lady Brewing Company | 558 | Anchorage | AK |
| State | medianABV | medianIBU | NumBreweries |
|---|---|---|---|
| AK | 0.0560 | 46.0 | 7 |
| AL | 0.0600 | 43.0 | 3 |
| AR | 0.0520 | 39.0 | 2 |
| AZ | 0.0550 | 20.5 | 11 |
| CA | 0.0580 | 42.0 | 39 |
| CO | 0.0605 | 40.0 | 47 |
## na_count ## BeerName 0 ## Beer_ID 0 ## ABV 62 ## IBU 1005 ## Style 0 ## Ounces 0 ## BreweryName 0 ## Brewery_ID 0 ## City 0 ## State 0
## State BeerName City ABV ## 1 CO Lee Hill Series Vol. 5 - Belgian Style Quadrupel Ale Boulder 0.128
## IBU Distribution
## State BeerName City IBU ## 1 OR Bitter Bitch Imperial IPA Astoria 138
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's ## 0.00100 0.05000 0.05600 0.05977 0.06700 0.12800 62
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's ## 4.00 21.00 35.00 42.71 64.00 138.00 1005
We recommend: Target Market: Arkansas, Mississippi, and Alabama State Headquarter: Mississippi